[dbo].[OrderSuperProductChildProductAttribute]

Property	Value
Row Count	0
Created	10:31:30 AM Tuesday, March 02, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:30 AM Tuesday, March 02, 2010

Last Modified

11:40:05 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key PK_OrderSuperProductChildProductAttribute: OrderSuperProductChildProductID\OrderSuperProductAttributeValueID$	OrderSuperProductChildProductID	int	4
$Cluster Primary Key PK_OrderSuperProductChildProductAttribute: OrderSuperProductChildProductID\OrderSuperProductAttributeValueID$	OrderSuperProductAttributeValueID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_OrderSuperProductChildProductAttribute: OrderSuperProductChildProductID\OrderSuperProductAttributeValueID$

Foreign Keys FK_OrderSuperProductChildProductAttribute_OrderSuperProductChildProduct: [dbo].[OrderSuperProductChildProduct].OrderSuperProductChildProductID

OrderSuperProductChildProductID

int

$Cluster Primary Key PK_OrderSuperProductChildProductAttribute: OrderSuperProductChildProductID\OrderSuperProductAttributeValueID$

Foreign Keys FK_OrderSuperProductChildProductAttribute_OrderSuperProductAttributeValue: [dbo].[OrderSuperProductAttributeValue].OrderSuperProductAttributeValueID

OrderSuperProductAttributeValueID

int

	Name	Columns	Unique
$Cluster Primary Key PK_OrderSuperProductChildProductAttribute: OrderSuperProductChildProductID\OrderSuperProductAttributeValueID$	PK_OrderSuperProductChildProductAttribute	OrderSuperProductChildProductID, OrderSuperProductAttributeValueID

Name

Columns

Unique

$Cluster Primary Key PK_OrderSuperProductChildProductAttribute: OrderSuperProductChildProductID\OrderSuperProductAttributeValueID$

PK_OrderSuperProductChildProductAttribute

OrderSuperProductChildProductID, OrderSuperProductAttributeValueID

Name	Update	Delete	Columns
FK_OrderSuperProductChildProductAttribute_OrderSuperProductAttributeValue	Cascade	Cascade	OrderSuperProductAttributeValueID->[dbo].[OrderSuperProductAttributeValue].[OrderSuperProductAttributeValueID]
FK_OrderSuperProductChildProductAttribute_OrderSuperProductChildProduct	Cascade	Cascade	OrderSuperProductChildProductID->[dbo].[OrderSuperProductChildProduct].[OrderSuperProductChildProductID]

Name

Update

Delete

Columns

FK_OrderSuperProductChildProductAttribute_OrderSuperProductAttributeValue

Cascade

OrderSuperProductAttributeValueID->[dbo].[OrderSuperProductAttributeValue].[OrderSuperProductAttributeValueID]

FK_OrderSuperProductChildProductAttribute_OrderSuperProductChildProduct

Cascade

OrderSuperProductChildProductID->[dbo].[OrderSuperProductChildProduct].[OrderSuperProductChildProductID]

SQL Script

CREATE TABLE [dbo].[OrderSuperProductChildProductAttribute]
(
[OrderSuperProductChildProductID] [int] NOT NULL,
[OrderSuperProductAttributeValueID] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OrderSuperProductChildProductAttribute] ADD CONSTRAINT [PK_OrderSuperProductChildProductAttribute] PRIMARY KEY CLUSTERED ([OrderSuperProductChildProductID], [OrderSuperProductAttributeValueID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrderSuperProductChildProductAttribute] ADD CONSTRAINT [FK_OrderSuperProductChildProductAttribute_OrderSuperProductAttributeValue] FOREIGN KEY ([OrderSuperProductAttributeValueID]) REFERENCES [dbo].[OrderSuperProductAttributeValue] ([OrderSuperProductAttributeValueID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[OrderSuperProductChildProductAttribute] ADD CONSTRAINT [FK_OrderSuperProductChildProductAttribute_OrderSuperProductChildProduct] FOREIGN KEY ([OrderSuperProductChildProductID]) REFERENCES [dbo].[OrderSuperProductChildProduct] ([OrderSuperProductChildProductID]) ON DELETE CASCADE ON UPDATE CASCADE
GO